<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0//EN" "http://www.w3.org/TR/REC-html40/strict.dtd">
<html><head><meta name="qrichtext" content="1" /><meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /><style type="text/css">
p, li { white-space: pre-wrap; }
</style></head><body style=" font-family:'MS Shell Dlg 2'; font-size:8pt; font-weight:400; font-style:normal;">
<table border="0" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;" width="100%" cellspacing="5" cellpadding="0">
<tr>
<td style=" vertical-align:middle;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><a name="ctl10_ctl03_PanelHeader"></a><span style=" font-family:'DejaVu Sans'; font-size:11pt; color:#c91f49;">Р</span><span style=" font-family:'DejaVu Sans'; font-size:11pt; color:#c91f49;">абота с датами DateSerial                                                        </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">        </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">        </span></p></td>
<td rowspan="3" style=" vertical-align:top; padding-left:10; padding-right:10; padding-top:10; padding-bottom:10;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'DejaVu Sans'; font-size:11pt;">            </span><a name="ctl10_ctl03_ImageLogo"></a><span style=" font-family:'DejaVu Sans'; font-size:11pt;"> </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">                   </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">        </span></p></td></tr>
<tr>
<td style=" vertical-align:top;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'DejaVu Sans'; font-size:11pt;">		                     </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">        </span></p></td></tr>
<tr>
<td style=" vertical-align:top; padding-left:15; padding-right:15; padding-top:15; padding-bottom:15;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'DejaVu Sans'; font-size:11pt;">            </span><a name="ctl10_ctl03_ProductDescription"></a><span style=" font-family:'DejaVu Sans'; font-size:11pt;">Н</span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">екотые данные вы можете получить из таблиц, используя функции времени. DateSerial - это такая фукнция</span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">        </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">        </span></p></td></tr></table>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'DejaVu Sans'; font-size:11pt;"><br />            </span></p>
<table border="0" style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px;" width="100%" cellspacing="0" cellpadding="0">
<tr>
<td style=" vertical-align:top;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'DejaVu Sans'; font-size:11pt;">                         </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">                    </span></p></td>
<td width="100%">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'DejaVu Sans'; font-size:11pt; font-weight:600;">                         </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">                    </span></p></td>
<td style=" vertical-align:middle;">
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'DejaVu Sans'; font-size:11pt;">                    </span><span style=" font-family:'DejaVu Sans'; font-size:11pt;">                            </span></p></td></tr></table>
<p style=" margin-top:0px; margin-bottom:0px; margin-left:0px; margin-right:0px; -qt-block-indent:0; text-indent:0px;"><span style=" font-family:'DejaVu Sans'; font-size:11pt;"><br /></span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#007700;">-- Использование функции Format</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;"><br /></span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#0000aa;">SELECT </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">Продукт</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">,</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;"> Цена</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">,</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;"> Format</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">(</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">Now</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">(),</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#ff0000;">'YYYY-MM-DD'</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">)</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;"> </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#0000aa;">as </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">ДатаЗаказа </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#0000aa;">FROM </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">Продукты<br /><br /></span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#007700;">-- Выборка между 2 датами, американский стандарт</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;"><br /></span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#0000aa;">SELECT </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">Дата </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#0000aa;">FROM </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">Данные </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#0000aa;">WHERE </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">(</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">[Дата] <br /></span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">BETWEEN </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">DateSerial</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">(</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#ff00ff;">Year</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">(</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#0000aa;">Date</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">()),</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#ff00ff;">Month</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">(</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#0000aa;">Date</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">())</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">-2</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">,</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">1</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">)</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;"> </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">And </span><span style=" font-family:'Arial Unicode MS'; font-size:14pt;">#2/20/2005#</span><span style=" font-family:'Arial Unicode MS'; font-size:14pt; color:#808080;">);</span></p></body></html>